
IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[ManageOrganizaionCreditCardSerial]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[ManageOrganizaionCreditCardSerial]

IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[CalcIncrementalDeductionFactor]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[CalcIncrementalDeductionFactor];


IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[Sp_Duty_Row]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[Sp_Duty_Row];

    
IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[STICirculatingGoodsWithoutTaxID]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[STICirculatingGoodsWithoutTaxID]
    

IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[STIGetInfoAcc]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[STIGetInfoAcc]


 if EXISTS 
 (select * from dbo.sysobjects where id = object_id(N'[dbo].[vw_EShopGoods]') and xtype='V')
     Drop view [dbo].[vw_EShopGoods]

    
 IF  EXISTS(SELECT name FROM sysobjects  WHERE name = 'History_Detail_Factors')
ALTER TABLE  dbo.History_Detail_Factors ALTER COLUMN Note NVARCHAR(250)


IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[SearchKhordehForoshi]')
          AND xtype IN ( N'FN', N'IF', N'TF' )
)
    DROP FUNCTION [dbo].[SearchKhordehForoshi]

